Printing Takes a Long Time in LS Retail
Problem (ISSUE-013)​
Printing sales receipts takes an unusually long time in LS Retail. The issue is caused by a large number of records in the Trans. Server Work Table that do not have a store value on the branch server or offline POS.
Symptoms​
- Printing receipts is noticeably slow.
- Users experience long waiting times at the POS when printing.
- System performance appears normal except when printing.
Solution​
Step 1: Open the Trans. Server Work Table​
- Open Object Designer.
- Search for and open the table: Trans. Server Work Table.
Step 2: Clean Up Invalid Records​
- Locate records where the Store field is empty or has no value.
- Locate records where the Key1 field does not match the valid patterns
VOUCHER±<RandomNumber>orAMRCARDS±<RandomString>. - Delete the records that do not have a valid store value.
Prevention​
- Regularly monitor the Trans. Server Work Table for records without a store value.
- Review integration or data-import processes to ensure that all transactions are created with a valid store value.
- Schedule periodic maintenance to clean up old or invalid work table records.